How to: Save a new workbook.
Solution:
Select 'Save' or 'Save As...' from the 'File' menu, specify the drive and the folder where the workbook should be saved, click 'Save'.
1) In Excel, select 'Save' or 'Save As...' from the 'File' menu. (The Save As dialog box appears.)
2) Select the drive where the workbook is to be saved from the 'Save in' drop-down list. (A list of folders within the drive appears in the middle of the Save As dialog box.)
3) (Optional) Open the desired folder:
a) Select (click) the folder.
b) Click 'Open'. (The folder opens, listing files and subfolders it contains.)
NOTE: To save the workbook in a subfolder, select the subfolder and click the 'Open'.
4) Type a filename for the workbook in the 'File name' drop-down list box.
NOTE: A filename can contain up to 255 characters, including spaces.
5) Select 'Microsoft Excel Workbook (*.xls)' from the 'Save as type' drop-down list.
6) Click 'Save'.